CREATE TABLE [dbo].[ListCommis]
(
[itab_n] [int] NOT NULL,
[Ik_Commis] [int] NOT NULL,
[Ik_Status] [int] NOT NULL
)
GO
ALTER TABLE [dbo].[ListCommis] ADD CONSTRAINT [ListCommisPrimary] PRIMARY KEY CLUSTERED  ([itab_n], [Ik_Commis])
GO
ALTER TABLE [dbo].[ListCommis] ADD CONSTRAINT [ListCommisCommisForeign] FOREIGN KEY ([Ik_Commis]) REFERENCES [dbo].[Commis] ([Ik_Commis]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ListCommis] ADD CONSTRAINT [ListCommisStatusForeign] FOREIGN KEY ([Ik_Status]) REFERENCES [dbo].[StatusInCommis] ([Ik_Status])
GO
ALTER TABLE [dbo].[ListCommis] ADD CONSTRAINT [ListCommisPrepodForeign] FOREIGN KEY ([itab_n]) REFERENCES [dbo].[Prepod] ([itab_n])
GO
